﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace Pharmacy_management_system
{
    class DangQianHang
    {
        public static string aa;
        public static string bb;
     //   public static string xb="";
     //   public static string nl="";
     //   public static string tz="";
     //   public static string rysj="";
     //   public static string cysj="";
        public static string cc;
        public static int i = 0;
        public  void change_button(string zhuyuan)//判断是否做调查
        {
            
            string sqllll = "select * from table_ak a  , diaochabiao_1 b  where a.inp_no=b.inp_no  and b.inp_no='"+zhuyuan+"' ";
            SqlConnection conn5566 = new SqlConnection(SQL.constr);
            conn5566.Open();
            SqlDataAdapter da = new SqlDataAdapter(sqllll,conn5566);
            DataTable dt = new DataTable();
            da.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                i = 1;
            }
            else 
            {
                i = 0;
            }





        }
    }
}
